TillMovementTransaction

Entity Definition

Logical Name : TillMovementTransaction
Physical Name : TR_MV_TL

A non-sales Transaction that records the physical movement of a Till (cash drawer insert) from a Workstation to a StoreSafe or vice versa.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32)
TillTenderRepositoryID (FK) The unique identifier for the Till TenderRepository that is being moved. ID_RPSTY_TND_TL Identity integer Till(AS_TL)
WorkstationID (FK) The unique identifier for the Workstation from which the Till is being taken. ID_WS Identity integer Workstation(AS_WS)
SafeTenderRepositoryID (FK) The unique identifier for the TENDER RESPOSITORY. ID_RPSTY_TND_SF Identity integer Safe(AS_SF)
OperatorID (FK) A unique, automatically assigned number used to identify a workstation OPERATOR. ID_OPR Identity integer Operator(PA_OPR)
MovementDirectionCode A code denoting the direction the Till is being moved. ie: From Safe to Workstation, From Workstation to Safe, From Safe to Operator, From Operator to Workstation, etc. CD_MV_DRC Code2 char(2)

Relationships

Parent Entity Verb Phrase Child Entity
Safe is source/destination of TillMovementTransaction
Operator is source/destination of TillMovementTransaction
Workstation is source/destination of TillMovementTransaction
Till is moved by TillMovementTransaction
TillMovementTransaction ends TillWorkstationAssignment
TillMovementTransaction starts TillWorkstationAssignment
ControlTransaction can be a TillMovementTransaction

Logical Views containing TillMovementTransaction

Logical View
Logical 02200 - Transaction Macro View
Logical 02400 - Control Transaction Macro View
Logical 02410 - Control Transaction - Sign On Off View
Logical 02420 - Control Transaction - Till Movement View
Logical 02500 - Tender Control Transaction - Macro View
Logical 02520 - Tender Control Transaction - Settlement View
Logical 03140 - Reporting - Store Operations - Workstation View
Logical 03160 - Reporting - Store Operations - Till View
Logical 10120 - Enterprise - Location, WkStn, Operator, Till